<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.6.1" />
	<meta name="robots" content="noindex" />

	<title>File models/backend/transferencia/mHacerTransferencia.php</title>

	<script type="text/javascript" src="resources/combined.js?144019575"></script>
	<script type="text/javascript" src="elementlist.js?2260620923"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?1532301413" />

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
			<h3>Packages</h3>
			<ul>
				<li><a href="package-CodeIgniter.html">CodeIgniter<span></span></a>
						<ul>
				<li><a href="package-CodeIgniter.Libraries.html">Libraries</a>
						</li>
							</ul></li>
				<li class="active"><a href="package-None.html">None</a>
						</li>
			</ul>
		</div>

		<hr />


		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-CargaMenu.html">CargaMenu</a></li>
				<li><a href="class-Configuracion.html">Configuracion</a></li>
				<li><a href="class-Cuenta.html">Cuenta</a></li>
				<li><a href="class-DatosPersonales.html">DatosPersonales</a></li>
				<li><a href="class-Deposito.html">Deposito</a></li>
				<li><a href="class-Format.html">Format</a></li>
				<li><a href="class-FPDF.html">FPDF</a></li>
				<li><a href="class-hacerTransferencia.html">hacerTransferencia</a></li>
				<li><a href="class-Hipoteca.html">Hipoteca</a></li>
				<li><a href="class-Home.html">Home</a></li>
				<li><a href="class-Inversiones.html">Inversiones</a></li>
				<li><a href="class-Login.html">Login</a></li>
				<li><a href="class-Macciones.html">Macciones</a></li>
				<li><a href="class-Mconfiguracion.html">Mconfiguracion</a></li>
				<li><a href="class-Mcuenta.html">Mcuenta</a></li>
				<li><a href="class-Mdatospersonales.html">Mdatospersonales</a></li>
				<li><a href="class-Mdeposito.html">Mdeposito</a></li>
				<li class="active"><a href="class-mHacerTransferencia.html">mHacerTransferencia</a></li>
				<li><a href="class-Minversion.html">Minversion</a></li>
				<li><a href="class-Mlogin.html">Mlogin</a></li>
				<li><a href="class-Mnotificacion.html">Mnotificacion</a></li>
				<li><a href="class-MobtenerListaValores.html">MobtenerListaValores</a></li>
				<li><a href="class-Mprestamo.html">Mprestamo</a></li>
				<li><a href="class-Mprincipal.html">Mprincipal</a></li>
				<li><a href="class-Msolicitud.html">Msolicitud</a></li>
				<li><a href="class-Mtarjeta.html">Mtarjeta</a></li>
				<li><a href="class-Musuarios.html">Musuarios</a></li>
				<li><a href="class-MY_Router.html">MY_Router</a></li>
				<li><a href="class-Notificacion.html">Notificacion</a></li>
				<li><a href="class-ObtenerListaValores.html">ObtenerListaValores</a></li>
				<li><a href="class-Prestamo.html">Prestamo</a></li>
				<li><a href="class-Principal.html">Principal</a></li>
				<li><a href="class-Solicitud.html">Solicitud</a></li>
				<li><a href="class-Tarjeta.html">Tarjeta</a></li>
				<li><a href="class-VerifyLogin.html">VerifyLogin</a></li>
			</ul>





		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="package-None.html" title="Summary of None"><span>Package</span></a>
			</li>
			<li>
				<a href="class-mHacerTransferencia.html" title="Summary of mHacerTransferencia"><span>Class</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><a href="#1" id="1" class="l"> 1: </a><span class="xlang">&lt;?php</span>
<a href="#2" id="2" class="l"> 2: </a>
<a href="#3" id="3" class="l"> 3: </a><span class="php-keyword1">Class</span> mHacerTransferencia <span class="php-keyword1">extends</span> CI_Model {
<a href="#4" id="4" class="l"> 4: </a>
<a href="#5" id="5" class="l"> 5: </a>    <span class="php-comment">/**
</span><a href="#6" id="6" class="l"> 6: </a><span class="php-comment">     * Recibe los datos para generar una transferencia, un movimiento y una notificacion, e inserta los datos en la BBDD
</span><a href="#7" id="7" class="l"> 7: </a><span class="php-comment">     *
</span><a href="#8" id="8" class="l"> 8: </a><span class="php-comment">     * @param array $data
</span><a href="#9" id="9" class="l"> 9: </a><span class="php-comment">     * @param integer $strIdCuentaOrigen
</span><a href="#10" id="10" class="l">10: </a><span class="php-comment">     * @param integer $idMovimiento
</span><a href="#11" id="11" class="l">11: </a><span class="php-comment">     * @param string $strCuenta
</span><a href="#12" id="12" class="l">12: </a><span class="php-comment">     * @param integer $idCliente
</span><a href="#13" id="13" class="l">13: </a><span class="php-comment">     * @param boolean $idDestino
</span><a href="#14" id="14" class="l">14: </a><span class="php-comment">     */</span>
<a href="#15" id="15" class="l">15: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> insertTransferencia(<span class="php-var">$data</span>, <span class="php-var">$strIdCuentaOrigen</span>, <span class="php-var">$strCuenta</span>, <span class="php-var">$idMovimiento</span>, <span class="php-var">$IdCliente</span>, <span class="php-var">$isDestino</span>) {
<a href="#16" id="16" class="l">16: </a>
<a href="#17" id="17" class="l">17: </a>        <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-quote">&quot;insert into transferencia(idMovimiento, idCuentaOrigen, cuentaDestino, porCuentaDe,referencia, beneficiario, conceptoAd)
</span><a href="#18" id="18" class="l">18: </a><span class="php-quote">                            values (&quot;</span> . <span class="php-var">$idMovimiento</span> . <span class="php-quote">&quot;,&quot;</span> . <span class="php-var">$strIdCuentaOrigen</span> . <span class="php-quote">&quot;,'&quot;</span> . <span class="php-var">$strCuenta</span> . <span class="php-quote">&quot;','&quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'txtPorCuentaDe'</span>] . <span class="php-quote">&quot;',
</span><a href="#19" id="19" class="l">19: </a><span class="php-quote">                            '&quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'txtReferencia'</span>] . <span class="php-quote">&quot;','&quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'txtBeneficiario'</span>] . <span class="php-quote">&quot;','&quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'txtConceptoAd'</span>] . <span class="php-quote">&quot;')&quot;</span>);
<a href="#20" id="20" class="l">20: </a>        <span class="php-var">$texto</span> = <span class="php-quote">&quot;&quot;</span>;
<a href="#21" id="21" class="l">21: </a>        <span class="php-var">$asunto</span> = <span class="php-quote">&quot;&quot;</span>;
<a href="#22" id="22" class="l">22: </a>        <span class="php-keyword1">if</span> (<span class="php-var">$isDestino</span> == <span class="php-num">0</span>) {
<a href="#23" id="23" class="l">23: </a>            <span class="php-var">$texto</span> = lang(<span class="php-quote">'hechoTransferencia'</span>) . <span class="php-quote">&quot; &quot;</span> . <span class="php-var">$strCuenta</span> . <span class="php-quote">&quot; &quot;</span> . lang(<span class="php-quote">'de'</span>) . <span class="php-quote">&quot; &quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'txtImporte'</span>];
<a href="#24" id="24" class="l">24: </a>            <span class="php-var">$asunto</span> = lang(<span class="php-quote">'transferenciaEmitida'</span>);
<a href="#25" id="25" class="l">25: </a>        } <span class="php-keyword1">else</span> {
<a href="#26" id="26" class="l">26: </a>            <span class="php-var">$texto</span> = lang(<span class="php-quote">'recibidoTransferencia'</span>) . <span class="php-quote">&quot; &quot;</span> . <span class="php-var">$strCuenta</span> . <span class="php-quote">&quot; &quot;</span> . lang(<span class="php-quote">'de'</span>) . <span class="php-quote">&quot; &quot;</span> . <span class="php-var">$data</span>[<span class="php-quote">'txtImporte'</span>];
<a href="#27" id="27" class="l">27: </a>            <span class="php-var">$asunto</span> = lang(<span class="php-quote">'transferenciaRecibida'</span>);
<a href="#28" id="28" class="l">28: </a>        }
<a href="#29" id="29" class="l">29: </a>        <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-quote">'insert into notificacion(text, idCliente, asunto)
</span><a href="#30" id="30" class="l">30: </a><span class="php-quote">        values(&quot;'</span> . <span class="php-var">$texto</span> . <span class="php-quote">'&quot;, '</span> . <span class="php-var">$IdCliente</span> . <span class="php-quote">', &quot;'</span> . <span class="php-var">$asunto</span> . <span class="php-quote">'&quot;)'</span>);
<a href="#31" id="31" class="l">31: </a>    }
<a href="#32" id="32" class="l">32: </a>
<a href="#33" id="33" class="l">33: </a>    <span class="php-comment">/**
</span><a href="#34" id="34" class="l">34: </a><span class="php-comment">     * Carga las transferencias habituales de un cliente, segun a que cuenta haga la transferencia, el beneficiario de la transferencia, y el concepto, y lo devuelve en un array de objetos.
</span><a href="#35" id="35" class="l">35: </a><span class="php-comment">     *
</span><a href="#36" id="36" class="l">36: </a><span class="php-comment">     * @param int $idCliente
</span><a href="#37" id="37" class="l">37: </a><span class="php-comment">     * @return mixed
</span><a href="#38" id="38" class="l">38: </a><span class="php-comment">     */</span>
<a href="#39" id="39" class="l">39: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> transferenciasHabituales(<span class="php-var">$idCliente</span>) {
<a href="#40" id="40" class="l">40: </a>        <span class="php-var">$this</span>-&gt;db-&gt;select(<span class="php-quote">'c.codigoEntidad, c.codigoOficina, c.codigoControl, c.codigoCuenta, c.saldo, cuentaDestino, beneficiario, conceptoAd, c.id as idCuenta'</span>, <span class="php-keyword1">false</span>);
<a href="#41" id="41" class="l">41: </a>        <span class="php-var">$this</span>-&gt;db-&gt;from(<span class="php-quote">'transferencia t, cuentaCliente cc, movimiento m, cuenta c'</span>);
<a href="#42" id="42" class="l">42: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'t.idMovimiento = m.id'</span>);
<a href="#43" id="43" class="l">43: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'m.idCuenta = c.id'</span>);
<a href="#44" id="44" class="l">44: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'c.id = cc.idCuenta'</span>);
<a href="#45" id="45" class="l">45: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'c.saldo &gt; 0'</span>);
<a href="#46" id="46" class="l">46: </a>        <span class="php-var">$this</span>-&gt;db-&gt;where(<span class="php-quote">'cc.idCliente = '</span> . <span class="php-var">$idCliente</span>);
<a href="#47" id="47" class="l">47: </a>        <span class="php-var">$this</span>-&gt;db-&gt;group_by(<span class="php-quote">'cuentaDestino'</span>);
<a href="#48" id="48" class="l">48: </a>        <span class="php-var">$this</span>-&gt;db-&gt;group_by(<span class="php-quote">'beneficiario'</span>);
<a href="#49" id="49" class="l">49: </a>        <span class="php-var">$this</span>-&gt;db-&gt;group_by(<span class="php-quote">'conceptoAd'</span>);
<a href="#50" id="50" class="l">50: </a>        <span class="php-var">$this</span>-&gt;db-&gt;order_by(<span class="php-quote">'count(*)'</span>, <span class="php-quote">'desc'</span>);
<a href="#51" id="51" class="l">51: </a>        <span class="php-var">$this</span>-&gt;db-&gt;limit(<span class="php-num">3</span>);
<a href="#52" id="52" class="l">52: </a>        <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;db-&gt;get()-&gt;result();
<a href="#53" id="53" class="l">53: </a>    }
<a href="#54" id="54" class="l">54: </a>
<a href="#55" id="55" class="l">55: </a>}
<a href="#56" id="56" class="l">56: </a>
<a href="#57" id="57" class="l">57: </a><span class="xlang">?&gt;</span></code></pre>

	<div id="footer">
		 API documentation generated by <a href="http://apigen.org">ApiGen 2.6.1</a>
	</div>
</div>
</div>
</body>
</html>
